{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Trans Record"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Trans Record","index":0,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Row","Item","Name","First\nPosition","Length","Format","Usage","3/30 Memo Def#","Value(s)","Comments"]
[null,null,null,"Full length",null,"A=alpha\nN=numeric","FAAD\nFFATA\nRA\nALL\nN/A"," ","*** unless otherwise noted, all alpha fields are left-justified, space filled and all numeric fields are right justified zero filled","8/12/2009  v3.01.11"]
["1","1","Catalog of Federal Domestic Assistance Program Number (CFDA)","1","8","A","ALL","C3","Not edited for Contract and Administrative Payment records."," The Catalog of Federal Domestic Assistance (CFDA) program number is a 5-digit unique identification which describes the type of program, assistance, project, or\nservice for a specific Federal entity. First two positions = 10-99, next position is a period “.”, next 3 positions = 000-999, last 2 positions are for future expansion. (1-7 sent to FAADS)"]
[{"$f":"$A3+1","v":2},"2","State Application Identifier Number (SAI)",{"$f":"$D3+$E3","v":9},"20","A","FAAD",null,"SAI number, \"SAI EXEMPT\", \"SAI NOT AVAILABLE\"\n","Positions 1-2 = Abbreviated Alpha State Title V, Chapter 2\nCode; Positions 3-4 = Year; Positions 5-6 = Month; Positions 7-8 = Day; Positions 9 =Hyphen (-); Positions 10-13 = Sequential Number; Positions 14-20 = Suffix (optional).\n\nIf the program being reported is not subject to State review in accordance with Executive Order 12372 and no number is reported, \"SAI EXEMPT\" is entered. If the program is subject to State review under EO 12372 but for some reason the SAI is not available, \"SAI NOT AVAILABLE\""]
[{"$f":"$A4+1","v":3},42,"Recipient Identifier",{"$f":"$D4+$E4","v":29},"13","A","FFATA","E.1","DUNS","Unique identifier of the entity receiving the award."]
[4,43,"Recipient Parent Identifier",42,"13","A","FFATA","E.2","DUNS","Unique identifier of the parent of the entity receiving the award."]
[5,3,"Recipient Name",55,"46","A","ALL","A","recipient name, \"MULTIPLE RECIPIENTS\"","For county aggregate records, will read \"MULTIPLE RECIPIENTS\". (1-45 sent to FAADS)"]
[6,45,"Recipient Street Address1",101,"64","A","FFATA","D.1"]
[7,46,"Recipient Street Address2",165,"64","A","FFATA","D.1"]
[8,7,"Recipient City Code",229,"5","A","FAAD"," ","FIPS 55-3 / INCITS 446-2008","census code / place code"]
[9,8,"Recipient City Name",234,"35","A","ALL","D.1",null,"(1-21 sent to FAADS)"]
[10,9,"Recipient County Code",269,"3","A","FAAD"," ","FIPS 6-4 / INCITS 31:200x"]
[11,10,"Recipient County Name",272,"35","A","FAAD","D.1",null,"(1-21 sent to FAADS)"]
[12,11,"Recipient State Code",307,"2","A","FAAD"," ","FIPS 5-2 / INCITS 38:200x","Numeric version, eg. Alabama = \"01\""]
[{"$f":"$A14+1","v":13},71,"Recipient State Name",309,"2","A","FFATA","D.1","FIPS 5-2 / INCITS 38:200x","Alpha state name, eg. Arizona = \"AZ\""]
[14,12,"Recipient Zip Code",311,"9","A","ALL","D.1","web=USPS service\nbatch=Finalist package"]
[15,47,"Recipient Country Code",320,"2","A","N/A","D.1","FIPS 10-4 or equivalent"]
[16,64,"Recipient Country Name",322,"28","A","N/A","D.1","FIPS 10-4 or equivalent"]
[17,25,"Recipient Congressional District",350,"2","A","ALL","D.1","www.zipinfo.com table","Code for congressional district of the recipient.\n\nFor a congressional district at large, a \"00\" is entered. For jurisdictions with a nonvoting delegate, a \"98\" is entered. For jurisdictions with no representative, the designation \"99\" is entered. Where a jurisdiction is included in more than one congressional district, a code \"90\" might be used when a more precise notation is not available."]
[18,13,"Starting Date",352,"8","A","ALL",null,"YYYYMMDD","When the funds became/become available for the actual beginning of the project. (3-8 sent to FAADS)"]
[19,14,"Ending Date",360,"8","A","ALL",null,"YYYYMMDD","The scheduled completion date of the project.\n(3-8 sent to FAADS)"]
[{"$f":"$A21+1","v":20},17,"Project Description/Award Description",{"$f":"$D21+$E21","v":368},"148","A","ALL","C.5",null,"A brief narrative of the project being funded. \n(1-149 sent to FAADS)"]
[{"$f":"$A22+1","v":21},17.5,"Dun & Bradstreet Confidence Code",{"$f":"$D22+$E22","v":516},"2","A","FFATA"," ",null,"Confidence Code supplied by D&B"]
[22,23,"Recipient Type",518,"2","A","ALL",null,"Government codes:\n00 = State government\n01 = county government\n02 = city or township government\n04 = special district government\n05 = independent school district\n06 = State controlled institution of higher education\nNonprofit agencies:\n11 = Indian tribe\n12 = other nonprofit\nPrivate:\n20 = private higher education\n21 = individual\n22 = profit organization\n23 = small business\n25 = all other\n88 = Federal government","Identifies the type of recipient or borrower\n\nNOTE: a value of 88 is only valid for ACFO/FS administrative payments records.   Do not use it for regular awards records as it will not pass edits with OMB or Census."]
[23,24,"Action Type",520,"1","A","ALL",null,"A = new assistance action\nB = continuation (funding in succeeding budget period which stemmed\nfrom prior agreement to fund - amount of the current action)\nC = revision (any change in Federal Government's financial obligation\nor contingent liability in existing assistance transaction - amount of\nthe change in funding)\nD = funding adjustment to completed project.\nE= Disbursement\nF= Disbursement adjustment","Identifies the nature of the award."]
[24,26,"Federal Agency/Organizational Unit Code",521,"4","A","ALL","C.2","FIPS 95-2 or equivalent","Agency/bureau sequencing numeric code"]
[25,27,"Federal Award Identifier Number (FAI)",525,"16","A","ALL","C.6",null,"The number reflects each Federal agency's unique coding system for identifying individual assistance awards. \nEntries are left justified, space filled.\na. Core number  = first 16 characters\nThis field must be unique within each agency when combined with the FAIN Mod4 (item 27.2) and the Program Source (item 63)"]
[26,27.2,"Federal Award Identifier Number (FAI) Mod4",541,"4","A","ALL","C.6",null,"The number reflects each Federal agency's unique coding system for identifying individual assistance awards. \nEntries are left justified, space filled.\nb. Modification number = last 4 character\nThis field must be unique within each agency when combined with the FAIN (item 27) and the Program Source (item 63)"]
[27,27.5,"Federal Award Identifier Number (FAI) Mod2",545,"2","A","NA",null,null,"The number reflects each Federal agency's unique coding system for identifying individual assistance awards. \nEntries are left justified, space filled.\nc. Modification number = 2 characters\nThis field is no longer included as part of the key.  If data is sent in this field it will be stored but it will not be reported to Recovery Act (RA) and in the future for FAADS/FFATA."]
[28,29,"FAAD/FFATA Federal Amount",547,"18","N","ALL","B.1","S9(14).9(2)","Signed decimal. (FAAD - Negative amount indicates decrease in all reported Federal funding.)"]
[29,29.5,"FFATA Subsidy Cost Amount",565,"18","N","FFATA","B.1","S9(14).9(2)","Signed decimal."]
[30,31,"FAAD Non Federal Amount",583,"18","N","FAAD",null,"S9(14).9(2)","Signed decimal. (FAAD - Negative amount indicates decrease in all reported non-Federal funding.)"]
[31,32,"Award Obligation Action Date",601,"8","A","ALL","B.2","YYYYMMDD","Date the agreement was signed and funds were obligated.\nFor county aggregate records, entry will be the last day of the month.  (3-8 sent to FAADS)"]
[32,33,"Assistance Transaction Type",609,"2","A","ALL","C.1","01 = revenue sharing\n02 = block grant\n03 = formula grant\n04 = project grant\n05 = cooperative agreement\n06 = direct payment for specified use, as a subsidy or other\nnon-reimbursable direct financial aid\n07 = direct loan\n08 = guaranteed/insured loan\n09 = insurance\n10 = direct payment with unrestricted use (retirement,\npension, veterans benefits, etc.)\n11 = other reimbursable, contingent, intangible, or indirect\nfinancial assistance\n5C = IAS (ARRA) Contract\n5D = IAS (ARRA) Delivery Order\n5P = IAS (ARRA) Purchase Order \nGS = Goods/Service (ARRA)\nSB = Salaries/Benefits (ARRA)\nTR = Travel (ARRA)","Codes 5C, 5D, 5P, GS, SB and TR are for Recovery Act reporting only and only used by OPPM and ACFO/FS."]
[33,34,"Recipient/Record Type",611,"1","A","ALL",null,"1 = county aggregate reporting\n2 = action-by-action reporting\n","FAADS only accepts values of 1 & 2.  ARRA accepts 1 & 2.   FFATA only accepts a 2 BUT since ARRA records are FFATA records by default, values of 1 & 2 will also be in FFATA."]
[34,35,"Correction/Late Indicator",612,"1","A","ALL",null,"C =  indicates replacement/modification of existing record.\nD = indicates deletion of existing record\nL = indicates award that should have been reported in prior period.\nblank = current entry"]
[35,36,"Fiscal Year and Quarter Correction",613,"5","A","ALL",null,"YYYYQ","Designation of the fiscal year and quarter to which the corrected or late record applies. Blank for current records. (3-5 sent to FAADS)"]
[36,37,"Place Of Performance Code",618,"7","A","FAAD","D.2","State:\nThe first two positions are the numeric FIPS code for the State, territory, or the District of Columbia. A \"00\" code followed by five asterisks (*) indicates a multi-State project. A \"00\" numeric code followed by \"FORGN\" in the next five positions indicates the place of performance is in a foreign country.\nCounty or city:\nPositions 3-7 indicate the principal county or city of performance (project location). If the project is Statewide, asterisks appear. If the project is countywide, or in more than one county, the three character numeric FIPS code for the county, or county of principal performance, appears in positions 5-7, preceded by two asterisks. All FAADS transactions reported on a county aggregate basis are in the countywide format. If the principal place of performance is a particular city, the five-character numeric FIPS 55-3 place code is in positions 3-7.","Code for the principal place of performance of the project being funded."]
[37,38,"Minority Business or Minority Education Enterprise Indicator (MBE)",625,"1","A","FAAD",null,"space, \"B\", \"E\"","A minority business is a business enterprise in which at least 51% is owned by one or more minority individuals. Minority education means any higher education institution in the United States and territories whose student enrollment is comprised of 50% or more of minority individuals."]
[38,50,"Performance Street Address1",626,"64","A","FFATA","D.2",null,"May be blank in the case where the location of performance is a tract of land without a street address."]
[39,51,"Performance Street Address2",690,"64","A","FFATA","D.2",null,"May be blank in the case where the location of performance is a tract of land without a street address."]
[40,65,"Performance City Name",754,"35","A","FFATA","D.2"]
[41,66,"Performance State Name",789,"2","A","FFATA","D.2","FIPS 5-2 or equivalent","Alpha state name, ie. Arizona = \"AZ\""]
[42,67,"Performance Country Name",791,"28","A","FFATA","D.2","FIPS 10-4 or equivalent"]
[43,68,"Performance Zip Code",819,"9","A","FFATA"," ","web=USPS service\nbatch=Finalist package"]
[44,57,"Performance Congressional District",828,"2","A","FFATA","D.2","www.zipinfo.com table","Code for congressional district of the place of performance.\n\nFor a congressional district at large, a \"00\" is entered. For jurisdictions with a nonvoting delegate, a \"98\" is entered. For jurisdictions with no representative, the designation \"99\" is entered. Where a jurisdiction is included in more than one congressional district, a code \"90\" might be used when a more precise notation is not available."]
[45,63,"Program Source",830,"9","A","FFATA","C.4","XX-XXXX, XXxXXXX, XX9/9XXXX, XX9XXXX,\nXXXXXX\n\nXXXX…..","The account(s) from which the money is drawn.  \n2 digits Agency code (for USDA is 12).  \nDash follows in the third position or  if \"X\" then it is “no year” funds, if a number, it signifies the fiscal year, if multiple years it will be 7/8 for 07-08 time frame.\n4 digit identifier which references to the appropriated funds, or all numbers.\nThis field must be unique within each record when combined with the FAIN (item 27) and the FAIN Mod4 (item 27.2) .\n\nFormat also valid that has first four positions made up of two agency codes, e.g. 1214 followed by the same values as the examples above.\n"]
[46,69,"Sub Award Program Federal Award Identifier Number (FAI)",839,"16","A","FFATA",null,"future","future"]
[47,69.2,"Sub Award Program Federal Award Identifier Number (FAI) Mod4",855,"4","A","FFATA",null,"future","future"]
[46,69.5,"Sub Award Program Federal Award Identifier Number (FAI) Mod2",859,"2","A","FFATA",null,"future","future"]
[47,70,"Transmission Location",861,"2","N","ALL"," ","00 unless instructed otherwise\n01  assigned to all FSA transmitted records\n02 assigned to all Recovery Act Administrative Cost records\n03 assigned to all Recovery Act Contracts records","Used to identify users with multiple transmission locations."]
[48,72,"Paid Disbursement",863,"18","N","RA"," ","S9(14).9(2)","Signed decimal. "]
[49,73,"future",881,"18","N","TBD"," ","future","future"]
[50,74,"Recipient Country Code 3",899,"3","A","FFATA"," ","ISO 3166-1, 3 character country code e.g. United States = USA","Requested by OMB to aid in reporting foreign locations"]
[51,75,"Performance Country Code 3",902,"3","A","FFATA"," ","ISO 3166-1, 3 character country code e.g. United States = USA","Requested by OMB to aid in reporting foreign locations"]
[52,76,"Recovery Indicator",905,"1","A","RA"," ","R or blank","Used to identify Recovery Act award records"]